<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Jialeo\LaravelSchemaExtend\Schema;

class AlterStartBusinessIsNull extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        \Illuminate\Support\Facades\DB::statement("ALTER TABLE `open_shop_start_business`
MODIFY COLUMN `eatInTotal` tinyint(3) UNSIGNED NULL COMMENT '堂食位数' AFTER `submitTime`,
MODIFY COLUMN `hasMonitorUint` tinyint(3) UNSIGNED NULL COMMENT '监控落地 [ 1:是 2:否 ]' AFTER `eatInTotal`,
MODIFY COLUMN `hasRight` tinyint(3) UNSIGNED NULL COMMENT '有无竞对 [ 1:有 2:无 ]' AFTER `hasMonitorUint`,
MODIFY COLUMN `employmentExperience` tinyint(3) UNSIGNED NULL COMMENT '从业经验 [ 1:有 2:无 ]' AFTER `sellChannel`,
MODIFY COLUMN `managementInput` tinyint(3) UNSIGNED NULL COMMENT '经营投入 [ 1:全职参与 2:休息日参与 3:托管 ]' AFTER `employmentExperience`,
MODIFY COLUMN `degreeCooperation` tinyint(3) UNSIGNED NULL COMMENT '配合程度 [ 1:高 2:中 3:低 ]' AFTER `managementInput`,
MODIFY COLUMN `sellPriceType` tinyint(3) UNSIGNED NULL COMMENT '执行售价 [ 1:自选统一价 2:自选上浮价 3:自选下调价 4:自选特殊场景价 5:点单统一价 6:点单上浮价 7:点单下调价 8:点单特殊场景价 ]' AFTER `startBusinessTime`,
MODIFY COLUMN `staffCount` int(10) UNSIGNED NULL COMMENT '员工数' AFTER `menuCategory`,
MODIFY COLUMN `monthlyWages` int(10) UNSIGNED NULL COMMENT '月工资金额' AFTER `staffCount`;");
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
